/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: WHY
 * Date: 2023-02-18
 * Time: 23:30
 */
public class Test {
    public static void main(String[] args) {
        mysql> use java107;
        Database changed
        mysql> desc table goods;
        ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table goods' at line 1
        mysql> desc table goods;
        ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table goods' at line 1
        mysql> show table goods;
        ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'goods' at line 1
        mysql> show databases;
        +--------------------+
                | Database           |
                +--------------------+
                | information_schema |
| java105            |
| java107            |
| java108            |
| mysql              |
| performance_schema |
| sys                |
                +--------------------+
                        7 rows in set (0.01 sec)

        mysql> use java108;
        Database changed
        mysql> desc table goods;
        ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table goods' at line 1
        mysql> desc goods;
        +-------------+-------------+------+-----+---------+-------+
                | Field       | Type        | Null | Key | Default | Extra |
                +-------------+-------------+------+-----+---------+-------+
                | name        | varchar(20) | YES  |     | NULL    |       |
| price       | int(11)     | YES  |     | NULL    |       |
| reserve     | int(11)     | YES  |     | NULL    |       |
| descbrition | varchar(20) | YES  |     | NULL    |       |
        +-------------+-------------+------+-----+---------+-------+
                4 rows in set (0.01 sec)

        mysql> insert into goods values ('学生书包',18.91,101,null);
        Query OK, 1 row affected (0.01 sec)

        mysql> desc goods;
        +-------------+-------------+------+-----+---------+-------+
                | Field       | Type        | Null | Key | Default | Extra |
                +-------------+-------------+------+-----+---------+-------+
                | name        | varchar(20) | YES  |     | NULL    |       |
| price       | int(11)     | YES  |     | NULL    |       |
| reserve     | int(11)     | YES  |     | NULL    |       |
| descbrition | varchar(20) | YES  |     | NULL    |       |
        +-------------+-------------+------+-----+---------+-------+
                4 rows in set (0.00 sec)

        mysql> select* from goods;
        +--------------+-------+---------+-------------+
                | name         | price | reserve | descbrition |
                +--------------+-------+---------+-------------+
                | 学生书包     |    19 |     101 | NULL        |
                +--------------+-------+---------+-------------+
                        1 row in set (0.00 sec)

        mysql>
    }
}
